import { Pojo } from '../lib/db/Pojo';
import * as Sequelize from 'sequelize';
import sequelize from '../lib/db/mssql';


//保存同步的钉钉人员数据-----mysql数据库
export interface CorpEmplModel extends Pojo {
    userid: string;
    name:string;
    username: string;
    jobnumber: string;
    telephone:string;
    comment:number;
}
export interface corpEmplModelInstance extends Sequelize.Instance<CorpEmplModel>, CorpEmplModel {
}


export const corpEmplModel = sequelize.define<corpEmplModelInstance, CorpEmplModel>('corpEmpl', {
    userid: Sequelize.STRING,
    name:Sequelize.STRING,
    username: Sequelize.STRING,
    jobnumber: Sequelize.STRING,
    telephone:Sequelize.STRING,
    comment:Sequelize.INTEGER
});

corpEmplModel.sync();
export default corpEmplModel;